/*
 Navicat Premium Data Transfer

 Source Server         : VM-Mssql
 Source Server Type    : SQL Server
 Source Server Version : 10501600
 Source Host           : 10.1.233.6:1433
 Source Catalog        : MemberManagementDB
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 10501600
 File Encoding         : 65001

 Date: 01/09/2021 13:32:51
*/


-- ----------------------------
-- Table structure for Balance
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Balance]') AND type IN ('U'))
	DROP TABLE [dbo].[Balance]
GO

CREATE TABLE [dbo].[Balance] (
  [CardNo] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Balance] float(53)  NOT NULL,
  [BalanceGift] int  NOT NULL
)
GO

ALTER TABLE [dbo].[Balance] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of Balance
-- ----------------------------
INSERT INTO [dbo].[Balance] ([CardNo], [Balance], [BalanceGift]) VALUES (N'2979858', N'2910', N'4')
GO

INSERT INTO [dbo].[Balance] ([CardNo], [Balance], [BalanceGift]) VALUES (N'3272158', N'3000', N'4')
GO

INSERT INTO [dbo].[Balance] ([CardNo], [Balance], [BalanceGift]) VALUES (N'4421748', N'2000', N'4')
GO

INSERT INTO [dbo].[Balance] ([CardNo], [Balance], [BalanceGift]) VALUES (N'4591626', N'400', N'2')
GO

INSERT INTO [dbo].[Balance] ([CardNo], [Balance], [BalanceGift]) VALUES (N'5253131', N'2000', N'4')
GO

INSERT INTO [dbo].[Balance] ([CardNo], [Balance], [BalanceGift]) VALUES (N'6870325', N'9930', N'1')
GO

INSERT INTO [dbo].[Balance] ([CardNo], [Balance], [BalanceGift]) VALUES (N'8725159', N'1380', N'3')
GO


-- ----------------------------
-- Table structure for ConsumptionPatterns
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[ConsumptionPatterns]') AND type IN ('U'))
	DROP TABLE [dbo].[ConsumptionPatterns]
GO

CREATE TABLE [dbo].[ConsumptionPatterns] (
  [ConsumptionPatternsNo] int  IDENTITY(1,1) NOT NULL,
  [TypeName] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL
)
GO

ALTER TABLE [dbo].[ConsumptionPatterns] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of ConsumptionPatterns
-- ----------------------------
SET IDENTITY_INSERT [dbo].[ConsumptionPatterns] ON
GO

INSERT INTO [dbo].[ConsumptionPatterns] ([ConsumptionPatternsNo], [TypeName]) VALUES (N'1', N'微信')
GO

INSERT INTO [dbo].[ConsumptionPatterns] ([ConsumptionPatternsNo], [TypeName]) VALUES (N'2', N'手机')
GO

INSERT INTO [dbo].[ConsumptionPatterns] ([ConsumptionPatternsNo], [TypeName]) VALUES (N'3', N'卡号')
GO

INSERT INTO [dbo].[ConsumptionPatterns] ([ConsumptionPatternsNo], [TypeName]) VALUES (N'4', N'普通消费')
GO

SET IDENTITY_INSERT [dbo].[ConsumptionPatterns] OFF
GO


-- ----------------------------
-- Table structure for ConsumptionType
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[ConsumptionType]') AND type IN ('U'))
	DROP TABLE [dbo].[ConsumptionType]
GO

CREATE TABLE [dbo].[ConsumptionType] (
  [ConsumptionTypeNo] int  IDENTITY(1,1) NOT NULL,
  [TypeName] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Price] float(53)  NOT NULL,
  [Enable] nvarchar(15) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [DueToTime] datetime  NOT NULL
)
GO

ALTER TABLE [dbo].[ConsumptionType] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of ConsumptionType
-- ----------------------------
SET IDENTITY_INSERT [dbo].[ConsumptionType] ON
GO

INSERT INTO [dbo].[ConsumptionType] ([ConsumptionTypeNo], [TypeName], [Price], [Enable], [DueToTime]) VALUES (N'1', N'理发', N'25', N'启用', N'2020-10-23 00:00:00.000')
GO

INSERT INTO [dbo].[ConsumptionType] ([ConsumptionTypeNo], [TypeName], [Price], [Enable], [DueToTime]) VALUES (N'2', N'洗头', N'50', N'启用', N'2020-10-25 00:00:00.000')
GO

INSERT INTO [dbo].[ConsumptionType] ([ConsumptionTypeNo], [TypeName], [Price], [Enable], [DueToTime]) VALUES (N'3', N'染发', N'300', N'启用', N'2020-12-20 00:00:00.000')
GO

INSERT INTO [dbo].[ConsumptionType] ([ConsumptionTypeNo], [TypeName], [Price], [Enable], [DueToTime]) VALUES (N'4', N'烫头', N'600', N'启用', N'2020-10-30 00:00:00.000')
GO

SET IDENTITY_INSERT [dbo].[ConsumptionType] OFF
GO


-- ----------------------------
-- Table structure for MembershipGrade
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[MembershipGrade]') AND type IN ('U'))
	DROP TABLE [dbo].[MembershipGrade]
GO

CREATE TABLE [dbo].[MembershipGrade] (
  [LevelNo] int  IDENTITY(1,1) NOT NULL,
  [MembersName] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Money] float(53)  NOT NULL,
  [Discount] float(53)  NOT NULL,
  [Enable] nvarchar(15) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [DueToTime] datetime  NOT NULL
)
GO

ALTER TABLE [dbo].[MembershipGrade] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of MembershipGrade
-- ----------------------------
SET IDENTITY_INSERT [dbo].[MembershipGrade] ON
GO

INSERT INTO [dbo].[MembershipGrade] ([LevelNo], [MembersName], [Money], [Discount], [Enable], [DueToTime]) VALUES (N'1', N'普通会员', N'200', N'0.9', N'启用', N'2020-12-12 00:00:00.000')
GO

INSERT INTO [dbo].[MembershipGrade] ([LevelNo], [MembersName], [Money], [Discount], [Enable], [DueToTime]) VALUES (N'2', N'中级会员', N'400', N'0.8', N'启用', N'2020-12-12 00:00:00.000')
GO

INSERT INTO [dbo].[MembershipGrade] ([LevelNo], [MembersName], [Money], [Discount], [Enable], [DueToTime]) VALUES (N'3', N'高级会员', N'800', N'0.7', N'启用', N'2020-12-12 00:00:00.000')
GO

INSERT INTO [dbo].[MembershipGrade] ([LevelNo], [MembersName], [Money], [Discount], [Enable], [DueToTime]) VALUES (N'4', N'超级会员', N'2000', N'0.1', N'启用', N'2021-12-09 00:00:00.000')
GO

SET IDENTITY_INSERT [dbo].[MembershipGrade] OFF
GO


-- ----------------------------
-- Table structure for MethodPayment
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[MethodPayment]') AND type IN ('U'))
	DROP TABLE [dbo].[MethodPayment]
GO

CREATE TABLE [dbo].[MethodPayment] (
  [MethodPaymentNo] int  IDENTITY(1,1) NOT NULL,
  [TypeName] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL
)
GO

ALTER TABLE [dbo].[MethodPayment] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of MethodPayment
-- ----------------------------
SET IDENTITY_INSERT [dbo].[MethodPayment] ON
GO

INSERT INTO [dbo].[MethodPayment] ([MethodPaymentNo], [TypeName]) VALUES (N'1', N'微信')
GO

INSERT INTO [dbo].[MethodPayment] ([MethodPaymentNo], [TypeName]) VALUES (N'2', N'支付宝')
GO

INSERT INTO [dbo].[MethodPayment] ([MethodPaymentNo], [TypeName]) VALUES (N'3', N'会员卡')
GO

SET IDENTITY_INSERT [dbo].[MethodPayment] OFF
GO


-- ----------------------------
-- Table structure for Orders
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Orders]') AND type IN ('U'))
	DROP TABLE [dbo].[Orders]
GO

CREATE TABLE [dbo].[Orders] (
  [CardNo] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [Name] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [ConsumptionPatternsNo] int  NULL,
  [MethodPaymentNo] int  NOT NULL,
  [ConsumptionTypeNo] int  NOT NULL,
  [ConsumptionMoney] float(53)  NOT NULL,
  [ActualMoney] float(53)  NOT NULL,
  [DateConsumption] datetime  NOT NULL,
  [Note] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[Orders] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of Orders
-- ----------------------------
INSERT INTO [dbo].[Orders] ([CardNo], [Name], [ConsumptionPatternsNo], [MethodPaymentNo], [ConsumptionTypeNo], [ConsumptionMoney], [ActualMoney], [DateConsumption], [Note]) VALUES (N'2979858', N'温文', N'3', N'3', N'3', N'300', N'30', N'2020-10-27 16:28:28.240', N'')
GO

INSERT INTO [dbo].[Orders] ([CardNo], [Name], [ConsumptionPatternsNo], [MethodPaymentNo], [ConsumptionTypeNo], [ConsumptionMoney], [ActualMoney], [DateConsumption], [Note]) VALUES (N'2979858', N'温杰文', N'1', N'1', N'4', N'600', N'60', N'2020-10-27 16:28:57.353', N'')
GO

INSERT INTO [dbo].[Orders] ([CardNo], [Name], [ConsumptionPatternsNo], [MethodPaymentNo], [ConsumptionTypeNo], [ConsumptionMoney], [ActualMoney], [DateConsumption], [Note]) VALUES (N'8725159', N'朱老师', N'1', N'1', N'3', N'300', N'210', N'2020-10-28 10:34:04.697', N'')
GO

INSERT INTO [dbo].[Orders] ([CardNo], [Name], [ConsumptionPatternsNo], [MethodPaymentNo], [ConsumptionTypeNo], [ConsumptionMoney], [ActualMoney], [DateConsumption], [Note]) VALUES (N'8725159', N'朱老师', N'3', N'3', N'3', N'300', N'210', N'2020-10-28 10:34:49.413', N'')
GO

INSERT INTO [dbo].[Orders] ([CardNo], [Name], [ConsumptionPatternsNo], [MethodPaymentNo], [ConsumptionTypeNo], [ConsumptionMoney], [ActualMoney], [DateConsumption], [Note]) VALUES (N'6870325', N'小关', N'1', N'1', N'3', N'300', N'270', N'2020-10-27 16:37:49.000', N'')
GO


-- ----------------------------
-- Table structure for QueryMode
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[QueryMode]') AND type IN ('U'))
	DROP TABLE [dbo].[QueryMode]
GO

CREATE TABLE [dbo].[QueryMode] (
  [QueryNo] int  IDENTITY(1,1) NOT NULL,
  [QueryName] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL
)
GO

ALTER TABLE [dbo].[QueryMode] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of QueryMode
-- ----------------------------
SET IDENTITY_INSERT [dbo].[QueryMode] ON
GO

INSERT INTO [dbo].[QueryMode] ([QueryNo], [QueryName]) VALUES (N'1', N'微信号')
GO

INSERT INTO [dbo].[QueryMode] ([QueryNo], [QueryName]) VALUES (N'2', N'手机号')
GO

INSERT INTO [dbo].[QueryMode] ([QueryNo], [QueryName]) VALUES (N'3', N'姓名')
GO

INSERT INTO [dbo].[QueryMode] ([QueryNo], [QueryName]) VALUES (N'4', N'卡号')
GO

SET IDENTITY_INSERT [dbo].[QueryMode] OFF
GO


-- ----------------------------
-- Table structure for Recharge
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Recharge]') AND type IN ('U'))
	DROP TABLE [dbo].[Recharge]
GO

CREATE TABLE [dbo].[Recharge] (
  [CardNo] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Name] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [PaymentName] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Credit] float(53)  NOT NULL,
  [ActualMoney] float(53)  NOT NULL,
  [CreDate] datetime  NOT NULL,
  [MethodPaymentNo] int  NOT NULL
)
GO

ALTER TABLE [dbo].[Recharge] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of Recharge
-- ----------------------------
INSERT INTO [dbo].[Recharge] ([CardNo], [Name], [PaymentName], [Credit], [ActualMoney], [CreDate], [MethodPaymentNo]) VALUES (N'2979858', N'温某文', N'林某辉', N'1000', N'0', N'2020-10-27 16:27:36.310', N'1')
GO

INSERT INTO [dbo].[Recharge] ([CardNo], [Name], [PaymentName], [Credit], [ActualMoney], [CreDate], [MethodPaymentNo]) VALUES (N'3272158', N'郑某鹏', N'林某辉', N'1000', N'0', N'2020-10-27 16:28:05.920', N'1')
GO

INSERT INTO [dbo].[Recharge] ([CardNo], [Name], [PaymentName], [Credit], [ActualMoney], [CreDate], [MethodPaymentNo]) VALUES (N'6870325', N'小关', N'林', N'10000', N'0', N'2020-10-27 16:37:32.123', N'1')
GO

INSERT INTO [dbo].[Recharge] ([CardNo], [Name], [PaymentName], [Credit], [ActualMoney], [CreDate], [MethodPaymentNo]) VALUES (N'8725159', N'朱老师', N'林', N'1000', N'0', N'2020-10-28 10:32:21.663', N'1')
GO


-- ----------------------------
-- Table structure for Sms
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Sms]') AND type IN ('U'))
	DROP TABLE [dbo].[Sms]
GO

CREATE TABLE [dbo].[Sms] (
  [CardNo] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Name] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Phone] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [InDate] datetime  NOT NULL,
  [MessageText] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [MessageTypeNo] int  NOT NULL,
  [WhetherToSend] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL
)
GO

ALTER TABLE [dbo].[Sms] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of Sms
-- ----------------------------
INSERT INTO [dbo].[Sms] ([CardNo], [Name], [Phone], [InDate], [MessageText], [MessageTypeNo], [WhetherToSend]) VALUES (N'4421748', N'马某勋', N'18965138288', N'2020-10-27 15:43:38.067', N'尊敬的客户：马麒勋 您今天在本店开通：超级会员 卡号是：4421748 卡上余额：2000', N'1', N'发送成功')
GO

INSERT INTO [dbo].[Sms] ([CardNo], [Name], [Phone], [InDate], [MessageText], [MessageTypeNo], [WhetherToSend]) VALUES (N'4579162', N'林某辉', N'18559440650', N'2020-10-27 15:44:44.710', N'尊敬的客户：林鸿辉 您今天在本店开通：超级会员 卡号是：4579162 卡上余额：2000', N'1', N'发送成功')
GO

INSERT INTO [dbo].[Sms] ([CardNo], [Name], [Phone], [InDate], [MessageText], [MessageTypeNo], [WhetherToSend]) VALUES (N'3272158', N'郑某鹏', N'17720743464', N'2020-10-27 15:45:48.587', N'尊敬的客户：郑达鹏 您今天在本店开通：超级会员 卡号是：3272158 卡上余额：2000', N'1', N'发送成功')
GO

INSERT INTO [dbo].[Sms] ([CardNo], [Name], [Phone], [InDate], [MessageText], [MessageTypeNo], [WhetherToSend]) VALUES (N'5253131', N'罗某钰', N'18398992750', N'2020-10-27 15:47:50.087', N'尊敬的客户：罗绍钰 您今天在本店开通：超级会员 卡号是：5253131 卡上余额：2000', N'1', N'发送成功')
GO

INSERT INTO [dbo].[Sms] ([CardNo], [Name], [Phone], [InDate], [MessageText], [MessageTypeNo], [WhetherToSend]) VALUES (N'4591626', N'童某兵', N'18679631721', N'2020-10-27 15:48:54.587', N'尊敬的客户：童政兵 您今天在本店开通：中级会员 卡号是：4591626 卡上余额：400', N'1', N'发送成功')
GO

INSERT INTO [dbo].[Sms] ([CardNo], [Name], [Phone], [InDate], [MessageText], [MessageTypeNo], [WhetherToSend]) VALUES (N'2979858', N'温某文', N'15880523015', N'2020-10-27 15:51:10.540', N'尊敬的客户：温杰文 您今天在本店开通：超级会员 卡号是：2979858 卡上余额：2000', N'1', N'发送成功')
GO

INSERT INTO [dbo].[Sms] ([CardNo], [Name], [Phone], [InDate], [MessageText], [MessageTypeNo], [WhetherToSend]) VALUES (N'3085179', N'林某辉', N'18559440650', N'2020-10-27 16:05:31.400', N'尊敬的客户：林鸿辉 您今天在本店开通：超级会员 卡号是：3085179 卡上余额：2000', N'1', N'发送成功')
GO

INSERT INTO [dbo].[Sms] ([CardNo], [Name], [Phone], [InDate], [MessageText], [MessageTypeNo], [WhetherToSend]) VALUES (N'8725159', N'朱老师', N'15959210724', N'2020-10-28 10:34:49.983', N'尊敬的客户：朱老师 您今天在本店消费：210 卡号是：8725159 卡上余额：1380', N'3', N'发送成功')
GO


-- ----------------------------
-- Table structure for SmsType
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[SmsType]') AND type IN ('U'))
	DROP TABLE [dbo].[SmsType]
GO

CREATE TABLE [dbo].[SmsType] (
  [MessageTypeNo] int  IDENTITY(1,1) NOT NULL,
  [TypeName] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL
)
GO

ALTER TABLE [dbo].[SmsType] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of SmsType
-- ----------------------------
SET IDENTITY_INSERT [dbo].[SmsType] ON
GO

INSERT INTO [dbo].[SmsType] ([MessageTypeNo], [TypeName]) VALUES (N'1', N'开卡')
GO

INSERT INTO [dbo].[SmsType] ([MessageTypeNo], [TypeName]) VALUES (N'2', N'充值')
GO

INSERT INTO [dbo].[SmsType] ([MessageTypeNo], [TypeName]) VALUES (N'3', N'消费')
GO

INSERT INTO [dbo].[SmsType] ([MessageTypeNo], [TypeName]) VALUES (N'4', N'多久没来消费提醒')
GO

SET IDENTITY_INSERT [dbo].[SmsType] OFF
GO


-- ----------------------------
-- Table structure for sysdiagrams
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sysdiagrams]') AND type IN ('U'))
	DROP TABLE [dbo].[sysdiagrams]
GO

CREATE TABLE [dbo].[sysdiagrams] (
  [name] sysname  NOT NULL,
  [principal_id] int  NOT NULL,
  [diagram_id] int  IDENTITY(1,1) NOT NULL,
  [version] int  NULL,
  [definition] varbinary(max)  NULL
)
GO

ALTER TABLE [dbo].[sysdiagrams] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sysdiagrams
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sysdiagrams] ON
GO

INSERT INTO [dbo].[sysdiagrams] ([name], [principal_id], [diagram_id], [version], [definition]) VALUES (N'Diagram_0', N'1', N'1', N'1', 0xD0CF11E0A1B11AE1000000000000000000000000000000003E000300FEFF0900060000000000000000000000010000000100000000000000001000000200000001000000FEFFFFFF0000000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFDFFFFFF19000000FEFFFFFF0400000005000000060000000700000027000000090000000A0000000B0000000C0000000D0000000E0000000F000000100000001100000012000000130000001400000015000000160000001700000018000000FEFFFFFFFEFFFFFF1B0000001C0000001D0000001E0000001F00000020000000210000002200000023000000240000002500000026000000FEFFFFFF2800000029000000FEFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF52006F006F007400200045006E00740072007900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000016000500FFFFFFFFFFFFFFFF0200000000000000000000000000000000000000000000000000000000000000D0C4D52333ACD60103000000800E0000000000006600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000201FFFFFFFFFFFFFFFFFFFFFFFF0000000000000000000000000000000000000000000000000000000000000000000000000000000042090000000000006F000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000040002010100000004000000FFFFFFFF000000000000000000000000000000000000000000000000000000000000000000000000080000007A20000000000000010043006F006D0070004F0062006A0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000012000201FFFFFFFFFFFFFFFFFFFFFFFF000000000000000000000000000000000000000000000000000000000000000000000000260000005F000000000000000100000002000000030000000400000005000000060000000700000008000000090000000A0000000B0000000C0000000D0000000E0000000F000000100000001100000012000000130000001400000015000000160000001700000018000000190000001A0000001B0000001C0000001D0000001E0000001F000000200000002100000022000000230000002400000025000000FEFFFFFF27000000FEFFFFFFFEFFFFFF2A0000002B0000002C0000002D0000002E0000002F000000300000003100000032000000330000003400000035000000360000003700000038000000FEFFFFFFFEFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF000434000A1E500C05000080300000000F00FFFF5000000030000000007D0000D97F00008E45000071BC00003D89000078E7FFFF60DDFFFFDE805B10F195D011B0A000AA00BDCB5C00001800B300000006000080010000408622BC0253797374656D0089030000003C006B0000000900000000000000D9E6B0E91C81D011AD5100A0C90F5739F43B7F847F61C74385352986E1D552F8A0327DB2D86295428D98273C25A2DA2D00002800430000000000000053444DD2011FD1118E63006097D2DF4834C9D2777977D811907000065B840D9C00002800430000000000000051444DD2011FD1118E63006097D2DF4834C9D2777977D811907000065B840D9C1A0000003C080000009A010000003000A50900000700008001000000A002000000800000070000805363684772696400E21D0000C201000042616C616E63650000003C00A50900000700008002000000B802000000800000130000805363684772696400D449000038310000436F6E73756D7074696F6E5061747465726E730000003800A50900000700008003000000B0020000008000000F0000805363684772696400781E0000302A0000436F6E73756D7074696F6E547970650000003800A50900000700008004000000B0020000008000000F0000805363684772696400F0F1FFFFA41F00004D656D6265727368697047726164650000003800A50900000700008005000000AC020000008000000D0000805363684772696400D4490000D02000004D6574686F645061796D656E7405000000003000A509000007000080060000009E020000008000000600008053636847726964003E4900006AFFFFFF4F7264657273640000009400A5090000070000800D00000062000000018000006C000000436F6E74726F6C00A86C00003D0A00001C204D006500740068006F0064005000610079006D0065006E0074001D200E4E1C204F00720064006500720073001D204B4EF49584767351FB7C1C2046004B005F004F00720064006500720073005F004D006500740068006F0064005000610079006D0065006E0074001D2000002800B5010000070000800E000000310000005F00000002800000436F6E74726F6C00B47000004018000000009C00A50900000700008014000000620000000180000074000000436F6E74726F6C00E2410000D30A00001C2043006F006E00730075006D007000740069006F006E0054007900700065001D200E4E1C204F00720064006500720073001D204B4EF49584767351FB7C1C2046004B005F004F00720064006500720073005F0043006F006E00730075006D007000740069006F006E0054007900700065001D2000002800B50100000700008015000000310000006300000002800000436F6E74726F6C0058380000FD0C000000003000A50900000700008018000000A2020000008000000800008053636847726964005AF1FFFF14ECFFFF55736572496E666F00009C00A5090000070000801D000000620000000180000074000000436F6E74726F6C0083EDFFFF9F0200001C204D0065006D006200650072007300680069007000470072006100640065001D200E4E1C20550073006500720049006E0066006F001D204B4EF49584767351FB7C1C2046004B005F0055007300650072005F004D0065006D006200650072007300680069007000470072006100640065001D2000002800B5010000070000801E000000310000005F00000002800000436F6E74726F6C005EEFFFFFBE14000000008400A5090000070000801F00000062000000018000005C000000436F6E74726F6C00420B000059F0FFFF1C20550073006500720049006E0066006F001D200E4E1C20420061006C0061006E00630065001D204B4EF49584767351FB7C1C2046004B005F00420061006C0061006E00630065005F00550073006500720049006E0066006F001D2000002800B50100000700008020000000310000005700000002800000436F6E74726F6C6F5619000003F0FFFF00003000A50900000700008023000000A202000000800000080000805363684772696400A41F000082140000526563686172676500008800A50900000700008024000000620000000180000060000000436F6E74726F6C00420B000059F0FFFF1C20550073006500720049006E0066006F001D200E4E1C20520065006300680061007200670065001D204B4EF49584767351FB7C1C2046004B005F00520065006300680061007200670065005F00550073006500720049006E0066006F001D2000002800B50100000700008025000000310000005900000002800000436F6E74726F6C00B81600003A04000000009C00A50900000700008027000000620000000180000074000000436F6E74726F6C003E3F0000EB1F00001C204D006500740068006F0064005000610079006D0065006E0074001D200E4E1C20520065006300680061007200670065001D204B4EF49584767351FB7C1C2046004B005F00520065006300680061007200670065005F004D006500740068006F0064005000610079006D0065006E0074001D2000002800B50100000700008028000000310000006300000002800000436F6E74726F6C0029340000F127000000002C00A50900000700008029000000980200000080000003000080536368477269646FF4650000FAE7FFFF536D734700003000A5090000070000802A000000A002000000800000070000805363684772696400F41A00009ADEFFFF536D73547970650000007000A5090000070000802D000000620000000180000048000000436F6E74726F6C00DC34000075E3FFFF1C2053006D00730054007900700065001D200E4E1C2053006D0073001D204B4EF49584767351FB7C1C2046004B005F0053006D0073005F0053006D00730054007900700065001D2000002800B5010000070000802E000000310000004D00000002800000436F6E74726F6C00D843000085EEFFFF0000AC00A5090000070000802F000000620000000180000084000000436F6E74726F6C005C450000950C00001C2043006F006E00730075006D007000740069006F006E005000610074007400650072006E0073001D200E4E1C204F00720064006500720073001D204B4EF49584767351FB7C1C2046004B005F004F00720064006500720073005F0043006F006E00730075006D007000740069006F006E005000610074007400650072006E0073001D2000002800B50100000700008030000000310000006B00000002800000436F6E74726F6C00374700003822000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100FEFF030A0000FFFFFFFF00000000000000000000000000000000170000004D6963726F736F66742044445320466F726D20322E300010000000456D626564646564204F626A6563740000000000F439B27100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000021433412080000009E240000B8110000785634120700000014010000420061006C0061006E0063006500000069006E0064006F00770073002E0046006F0072006D0073002C002000430075006C0074007500720065003D006E00650075007400720061006C002C0020005000750062006C00690063004B006500790054006F006B0065006E003D0062003700370061003500630035003600310039003300340065003000380039000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005000000540000002C0000002C0000002C0000003400000000000000000000009E240000B8110000000000002D010000070000000C000000070000001C010000BC070000540600003A020000D0020000FE0100003804000038040000850200003804000055050000A2030000000000000100000015150000E30B000000000000030000000300000002000000020000001C010000AB0900000000000001000000C7110000FF05000000000000010000000100000002000000020000001C010000BC0700000100000000000000C7110000ED03000000000000000000000000000002000000020000001C010000BC0700000000000000000000072C0000DE20000000000000000000000D00000004000000040000001C010000BC07000024090000A005000078563412040000005800000001000000010000000B000000000000000100000002000000030000000400000005000000060000000700000008000000090000000A00000004000000640062006F00000008000000420061006C0061006E00630065000000214334120800000096240000810F000078563412070000001401000043006F006E00730075006D007000740069006F006E005000610074007400650072006E00730000002C002000560065007200730069006F006E003D0032002E0030002E0030002E0030002C002000430075006C0074007500720065003D006E00650075007400720061006C002C0020005000750062006C00690063004B006500790054006F006B0065006E003D00620037003700610035006300350036003100390033003400650030003800390000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005000000540000002C0000002C0000002C00000034000000000000000000000096240000810F0000000000002D010000070000000C000000070000001C010000BC070000540600003A020000D0020000FE0100003804000038040000850200003804000055050000A2030000000000000100000015150000B709000000000000020000000200000002000000020000001C010000AB0900000000000001000000C7110000ED03000000000000000000000000000002000000020000001C010000BC0700000100000000000000C7110000ED03000000000000000000000000000002000000020000001C010000BC0700000000000000000000072C0000DE20000000000000000000000D00000004000000040000001C010000BC07000024090000A005000078563412040000007000000001000000010000000B000000000000000100000002000000030000000400000005000000060000000700000008000000090000000A00000004000000640062006F0000001400000043006F006E00730075006D007000740069006F006E005000610074007400650072006E00730000002143341208000000962400009716000078563412070000001401000043006F006E00730075006D007000740069006F006E0054007900700065000000430075006C0074007500720065003D006E00650075007400720061006C002C0020005000750062006C00690063004B006500790054006F006B0065006E003D0062003000330066003500660037006600310031006400350030006100330061000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005000000540000002C0000002C0000002C0000003400000000000000000000009624000097160000000000002D010000070000000C000000070000001C010000BC070000540600003A020000D0020000FE0100003804000038040000850200003804000055050000A20300000000000001000000151500003A10000000000000050000000500000002000000020000001C010000AB0900000000000001000000C7110000FF05000000000000010000000100000002000000020000001C010000BC0700000100000000000000C7110000ED03000000000000000000000000000002000000020000001C010000BC0700000000000000000000072C0000DE20000000000000000000000D00000004000000040000001C010000BC07000024090000A005000078563412040000006800000001000000010000000B000000000000000100000002000000030000000400000005000000060000000700000008000000090000000A00000004000000640062006F0000001000000043006F006E00730075006D007000740069006F006E005400790070006500000021433412080000008D2500004F1B00007856341207000000140100004D0065006D0062006500720073006800690070004700720061006400650000006F0072006D0073002C002000560065007200730069006F006E003D0032002E0030002E0030002E0030002C002000430075006C0074007500720065003D006E00650075007400720061006C002C0020005000750062006C00690063004B006500790054006F006B0065006E003D00620037003700610035006300350036003100390033003400650030003800390000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005000000540000002C0000002C0000002C0000003400000000000000000000008D2500004F1B0000000000002D010000090000000C000000070000001C010000BC070000540600003A020000D0020000FE0100003804000038040000850200003804000055050000A20300000000000001000000161500006E13000000000000070000000700000002000000020000001C010000AB0900000000000001000000C7110000FF05000000000000010000000100000002000000020000001C010000BC0700000100000000000000C7110000ED03000000000000000000000000000002000000020000001C010000BC0700000000000000000000072C0000DE20000000000000000000000D00000004000000040000001C010000BC07000024090000A005000078563412040000006800000001000000010000000B000000000000000100000002000000030000000400000005000000060000000700000008000000090000000A00000004000000640062006F000000100000004D0065006D006200650072007300680069007000470072006100640065000000214334120800000096240000810F00007856341207000000140100004D006500740068006F0064005000610079006D0065006E00740000002E0046006F0072006D0073002C002000430075006C0074007500720065003D006E00650075007400720061006C002C0020005000750062006C00690063004B006500790054006F006B0065006E003D0062003700370061003500630035003600310039003300340065003000380039000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005000000540000002C0000002C0000002C00000034000000000000000000000096240000810F0000000000002D010000070000000C000000070000001C010000BC070000540600003A020000D0020000FE0100003804000038040000850200003804000055050000A2030000000000000100000015150000B709000000000000020000000200000002000000020000001C010000AB0900000000000001000000C7110000FF05000000000000010000000100000002000000020000001C010000BC0700000100000000000000C7110000ED03000000000000000000000000000002000000020000001C010000BC0700000000000000000000072C0000DE20000000000000000000000D00000004000000040000001C010000BC07000024090000A005000078563412040000006400000001000000010000000B000000000000000100000002000000030000000400000005000000060000000700000008000000090000000A00000004000000640062006F0000000E0000004D006500740068006F0064005000610079006D0065006E00740000002143341208000000962400004F1B00007856341207000000140100004F00720064006500720073000000440072006100770069006E0067002C002000430075006C0074007500720065003D006E00650075007400720061006C002C0020005000750062006C00690063004B006500790054006F006B0065006E003D0062003000330066003500660037006600310031006400350030006100330061000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005000000540000002C0000002C0000002C000000340000000000000000000000962400004F1B0000000000002D010000090000000C000000070000001C010000BC070000540600003A020000D0020000FE0100003804000038040000850200003804000055050000A20300000000000001000000151500009114000000000000070000000700000002000000020000001C010000AB0900000000000001000000C7110000FF05000000000000010000000100000002000000020000001C010000BC0700000100000000000000C7110000ED03000000000000000000000000000002000000020000001C010000BC0700000000000000000000072C0000DE20000000000000000000000D00000004000000040000001C010000BC07000024090000A005000078563412040000005600000001000000010000000B000000000000000100000002000000030000000400000005000000060000000700000008000000090000000A00000004000000640062006F000000070000004F0072006400650072007300000004000B006A6E0000AC26000005700000AC26000005700000B80B0000D46D0000B80B00000000000002000000F0F0F00000000000000000000000000000000000010000000E00000000000000B4700000401800008B0F00003E010000320000000100000200008B0F00003E0100000200000000000500008008000080010000001500018600009001905F010004CBCECCE5170046004B005F004F00720064006500720073005F004D006500740068006F0064005000610079006D0065006E00740004000B000E4300000C300000BA4400000C300000BA4400004E0C00003E4900004E0C00000000000002000000F0F0F0000000000000000000000000000000000001000000150000000000000058380000FD0C0000E61000003E01000064000000010000020000E61000003E0100000200000000000500008008000080010000001500018600009001905F010004CBCECCE5190046004B005F004F00720064006500720073005F0043006F006E00730075006D007000740069006F006E0054007900700065002143341208000000141B000020270000785634120700000014010000550073006500720049006E0066006F0000006E0064006F00770073002E0046006F0072006D0073002C002000560065007200730069006F006E003D0032002E0030002E0030002E0030002C002000430075006C0074007500720065003D006E00650075007400720061006C002C0020005000750062006C00690063004B006500790054006F006B0065006E003D00620037003700610035006300350036003100390033003400650030003800390000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005000000540000002C0000002C0000002C000000340000000000000000000000141B000020270000000000002D0100000D0000000C000000070000001C01000064050000740400003A020000D0020000FE010000EE02000038040000850200003804000055050000A20300000000000001000000C11200008C220000000000000C0000000C00000002000000020000001C010000160800000000000001000000BF0D00002A08000000000000020000000200000002000000020000001C010000640500000100000000000000BF0D0000ED03000000000000000000000000000002000000020000001C0100006405000000000000000000003F2000007D21000000000000000000000D00000004000000040000001C0100006405000063060000ED03000078563412040000005A00000001000000010000000B000000000000000100000002000000030000000400000005000000060000000700000008000000090000000A00000004000000640062006F00000009000000550073006500720049006E0066006F00000004000B00F0F1FFFF16260000AFEEFFFF16260000AFEEFFFF1A0400005AF1FFFF1A0400000000000002000000F0F0F00000000000000000000000000000000000010000001E000000000000005EEFFFFFBE1400008B0F00003E010000320000000100000200008B0F00003E0100000200000000000500008008000080010000001500018600009001905F010004CBCECCE5170046004B005F0055007300650072005F004D0065006D0062006500720073006800690070004700720061006400650004000B006E0C0000F0F1FFFFC2190000F0F1FFFFC21900009E070000E21D00009E0700000200000002000000F0F0F000000000000000000000000000000000000100000020000000000000005619000003F0FFFFD70C00003E0100001F000000010000020000D70C00003E0100000200000000000500008008000080010000001500018600009001905F010004CBCECCE5130046004B005F00420061006C0061006E00630065005F00550073006500720049006E0066006F002143341208000000C62000003A1400007856341207000000140100005200650063006800610072006700650000006E0064006F00770073002E0046006F0072006D0073002C002000560065007200730069006F006E003D0032002E0030002E0030002E0030002C002000430075006C0074007500720065003D006E00650075007400720061006C002C0020005000750062006C00690063004B006500790054006F006B0065006E003D00620037003700610035006300350036003100390033003400650030003800390000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005000000540000002C0000002C0000002C000000340000000000000000000000C62000003A140000000000002D010000070000000C000000070000001C01000081060000740400003A020000D0020000FE010000EE02000038040000850200003804000055050000A20300000000000001000000C1120000A60F000000000000040000000400000002000000020000001C010000160800000000000001000000BF0D00001906000000000000010000000100000002000000020000001C010000640500000100000000000000BF0D0000ED03000000000000000000000000000002000000020000001C0100006405000000000000000000003F2000007D21000000000000000000000D00000004000000040000001C0100006405000063060000ED03000078563412040000005A00000001000000010000000B000000000000000100000002000000030000000400000005000000060000000700000008000000090000000A00000004000000640062006F0000000900000052006500630068006100720067006500000004000B006E0C0000F0F1FFFF09160000F0F1FFFF091600005E1A0000A41F00005E1A00000000000002000000F0F0F00000000000000000000000000000000000010000002500000000000000B81600003A040000840D00003E01000032000000010000020000840D00003E010000020000000000FFFFFF0008000080010000001500018600009001905F010004CBCECCE5140046004B005F00520065006300680061007200670065005F00550073006500720049006E0066006F0004000B00D4490000422700001F450000422700001F450000662100006A400000662100000000000002000000F0F0F0000000000000000000000000000000000001000000280000000000000029340000F1270000E61000003E0100001B000000010000020000E61000003E010000020000000000FFFFFF0008000080010000001500018600009001905F010004CBCECCE5190046004B005F00520065006300680061007200670065005F004D006500740068006F0064005000610079006D0065006E0074002143341208000000F01C00009716000078563412070000001401000053006D007300000065006D002E00440072006100770069006E0067002C002000430075006C0074007500720065003D006E00650075007400720061006C002C0020005000750062006C00690063004B006500790054006F006B0065006E003D0062003000330066003500660037006600310031006400350030006100330061000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005000000540000002C0000002C0000002C000000340000000000000000000000F01C000097160000000000002D010000070000000C000000070000001C01000064050000B00400003A020000D0020000FE010000EE02000038040000850200003804000055050000A20300000000000001000000C11200000212000000000000050000000500000002000000020000001C010000160800000000000001000000BF0D0000ED03000000000000000000000000000002000000020000001C010000640500000100000000000000BF0D0000ED03000000000000000000000000000002000000020000001C0100006405000000000000000000003F2000007D21000000000000000000000D00000004000000040000001C0100006405000063060000ED03000078563412040000005000000001000000010000000B000000000000000100000002000000030000000400000005000000060000000700000008000000090000000A00000004000000640062006F0000000400000053006D00730000002143341208000000141B0000810F000078563412070000001401000053006D0073005400790070006500000072006100770069006E0067002C002000430075006C0074007500720065003D006E00650075007400720061006C002C0020005000750062006C00690063004B006500790054006F006B0065006E003D0062003000330066003500660037006600310031006400350030006100330061000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005000000540000002C0000002C0000002C000000340000000000000000000000141B0000810F0000000000002D010000070000000C000000070000001C01000064050000740400003A020000D0020000FE010000EE02000038040000850200003804000055050000A20300000000000001000000C1120000EC0A000000000000020000000200000002000000020000001C010000160800000000000001000000BF0D00001906000000000000010000000100000002000000020000001C010000640500000100000000000000BF0D0000ED03000000000000000000000000000002000000020000001C0100006405000000000000000000003F2000007D21000000000000000000000D00000004000000040000001C0100006405000063060000ED03000078563412040000005800000001000000010000000B000000000000000100000002000000030000000400000005000000060000000700000008000000090000000A00000004000000640062006F0000000800000053006D0073005400790070006500000004000B00083600000CE5FFFFFE4D00000CE5FFFFFE4D0000A0F6FFFFF4650000A0F6FFFF0000000002000000F0F0F00000000000000000000000000000000000010000002E00000000000000D843000085EEFFFF770900003E01000032000000010000020000770900003E010000020000000000FFFFFF0008000080010000001500018600009001905F010004CBCECCE50E0046004B005F0053006D0073005F0053006D007300540079007000650004000B00D449000014370000884600001437000088460000100E00003E490000100E00000000000002000000F0F0F0000000000000000000000000000000000001000000300000000000000037470000382200009A1300003E010000320000000100000200009A1300003E010000020000000000FFFFFF0008000080010000001500018600009001905F010004CBCECCE51D0046004B005F004F00720064006500720073005F0043006F006E00730075006D007000740069006F006E005000610074007400650072006E0073000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000300440064007300530074007200650061006D000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000160002000300000006000000FFFFFFFF0000000000000000000000000000000000000000000000000000000000000000000000001A000000C61900000000000053006300680065006D00610020005500440056002000440065006600610075006C0074000000000000000000000000000000000000000000000000000000000026000200FFFFFFFFFFFFFFFFFFFFFFFF000000000000000000000000000000000000000000000000000000000000000000000000280000001600000000000000440053005200450046002D0053004300480045004D0041002D0043004F004E00540045004E0054005300000000000000000000000000000000000000000000002C0002010500000007000000FFFFFFFF00000000000000000000000000000000000000000000000000000000000000000000000029000000E60300000000000053006300680065006D00610020005500440056002000440065006600610075006C007400200050006F007300740020005600360000000000000000000000000036000200FFFFFFFFFFFFFFFFFFFFFFFF0000000000000000000000000000000000000000000000000000000000000000000000003900000012000000000000000C00000078E7FFFF60DDFFFF0100260000007300630068005F006C006100620065006C0073005F00760069007300690062006C0065000000010000000B0000001E000000000000000000000000000000000000006400000000000000000000000000000000000000000000000000010000000100000000000000000000000000000000000000D00200000600280000004100630074006900760065005400610062006C00650056006900650077004D006F006400650000000100000008000400000030000000200000005400610062006C00650056006900650077004D006F00640065003A00300000000100000008003A00000034002C0030002C003200380034002C0030002C0031003900380030002C0031002C0031003600320030002C0035002C0031003000380030000000200000005400610062006C00650056006900650077004D006F00640065003A00310000000100000008001E00000032002C0030002C003200380034002C0030002C0032003400370035000000200000005400610062006C00650056006900650077004D006F00640065003A00320000000100000008001E00000032002C0030002C003200380034002C0030002C0031003900380030000000200000005400610062006C00650056006900650077004D006F00640065003A00330000000100000008001E00000032002C0030002C003200380034002C0030002C0031003900380030000000200000005400610062006C00650056006900650077004D006F00640065003A00340000000100000008003E00000034002C0030002C003200380034002C0030002C0031003900380030002C00310032002C0032003300340030002C00310031002C0031003400340030000000020000000200000000000000000000000000000000000000D00200000600280000004100630074006900760065005400610062006C00650056006900650077004D006F006400650000000100000008000400000030000000200000005400610062006C00650056006900650077004D006F00640065003A00300000000100000008003A00000034002C0030002C003200380034002C0030002C0031003900380030002C0031002C0031003600320030002C0035002C0031003000380030000000200000005400610062006C00650056006900650077004D006F00640065003A00310000000100000008001E00000032002C0030002C003200380034002C0030002C0032003400370035000000200000005400610062006C00650056006900650077004D006F00640065003A00320000000100000008001E00000032002C0030002C003200380034002C0030002C0031003900380030000000200000005400610062006C00650056006900650077004D006F00640065003A00330000000100000008001E00000032002C0030002C003200380034002C0030002C0031003900380030000000200000005400610062006C00650056006900650077004D006F00640065003A00340000000100000008003E00000034002C0030002C003200380034002C0030002C0031003900380030002C00310032002C0032003300340030002C00310031002C0031003400340030000000030000000300000000000000000000000000000000000000D00200000600280000004100630074006900760065005400610062006C00650056006900650077004D006F006400650000000100000008000400000030000000200000005400610062006C00650056006900650077004D006F00640065003A00300000000100000008003A00000034002C0030002C003200380034002C0030002C0031003900380030002C0031002C0031003600320030002C0035002C0031003000380030000000200000005400610062006C00650056006900650077004D006F00640065003A00310000000100000008001E00000032002C0030002C003200380034002C0030002C0032003400370035000000200000005400610062006C00650056006900650077004D006F00640065003A00320000000100000008001E00000032002C0030002C003200380034002C0030002C0031003900380030000000200000005400610062006C00650056006900650077004D006F00640065003A00330000000100000008001E00000032002C0030002C003200380034002C0030002C0031003900380030000000200000005400610062006C00650056006900650077004D006F00640065003A00340000000100000008003E00000034002C0030002C003200380034002C0030002C0031003900380030002C00310032002C0032003300340030002C00310031002C0031003400340030000000040000000400000000000000000000000000000000000000D00200000600280000004100630074006900760065005400610062006C00650056006900650077004D006F006400650000000100000008000400000030000000200000005400610062006C00650056006900650077004D006F00640065003A00300000000100000008003A00000034002C0030002C003200380034002C0030002C0031003900380030002C0031002C0031003600320030002C0035002C0031003000380030000000200000005400610062006C00650056006900650077004D006F00640065003A00310000000100000008001E00000032002C0030002C003200380034002C0030002C0032003400370035000000200000005400610062006C00650056006900650077004D006F00640065003A00320000000100000008001E00000032002C0030002C003200380034002C0030002C0031003900380030000000200000005400610062006C00650056006900650077004D006F00640065003A00330000000100000008001E00000032002C0030002C003200380034002C0030002C0031003900380030000000200000005400610062006C00650056006900650077004D006F00640065003A00340000000100000008003E00000034002C0030002C003200380034002C0030002C0031003900380030002C00310032002C0032003300340030002C00310031002C0031003400340030000000050000000500000000000000000000000000000000000000D00200000600280000004100630074006900760065005400610062006C00650056006900650077004D006F006400650000000100000008000400000030000000200000005400610062006C00650056006900650077004D006F00640065003A00300000000100000008003A00000034002C0030002C003200380034002C0030002C0031003900380030002C0031002C0031003600320030002C0035002C0031003000380030000000200000005400610062006C00650056006900650077004D006F00640065003A00310000000100000008001E00000032002C0030002C003200380034002C0030002C0032003400370035000000200000005400610062006C00650056006900650077004D006F00640065003A00320000000100000008001E00000032002C0030002C003200380034002C0030002C0031003900380030000000200000005400610062006C00650056006900650077004D006F00640065003A00330000000100000008001E00000032002C0030002C003200380034002C0030002C0031003900380030000000200000005400610062006C00650056006900650077004D006F00640065003A00340000000100000008003E00000034002C0030002C003200380034002C0030002C0031003900380030002C00310032002C0032003300340030002C00310031002C0031003400340030000000060000000600000000000000000000000000000000000000D00200000600280000004100630074006900760065005400610062006C00650056006900650077004D006F006400650000000100000008000400000030000000200000005400610062006C00650056006900650077004D006F00640065003A00300000000100000008003A00000034002C0030002C003200380034002C0030002C0031003900380030002C0031002C0031003600320030002C0035002C0031003000380030000000200000005400610062006C00650056006900650077004D006F00640065003A00310000000100000008001E00000032002C0030002C003200380034002C0030002C0032003400370035000000200000005400610062006C00650056006900650077004D006F00640065003A00320000000100000008001E00000032002C0030002C003200380034002C0030002C0031003900380030000000200000005400610062006C00650056006900650077004D006F00640065003A00330000000100000008001E00000032002C0030002C003200380034002C0030002C0031003900380030000000200000005400610062006C00650056006900650077004D006F00640065003A00340000000100000008003E00000034002C0030002C003200380034002C0030002C0031003900380030002C00310032002C0032003300340030002C00310031002C00310034003400300000000D0000000D00000000000000400000000100000001000000640062006F00000046004B005F004F00720064006500720073005F004D006500740068006F0064005000610079006D0065006E00740000000000000000000000C402000000000E0000000E0000000D000000080000000152030D6852030D0000000000000000AD070000000000140000001400000000000000440000000100750001000000640062006F00000046004B005F004F00720064006500720073005F0043006F006E00730075006D007000740069006F006E00540079007000650000000000000000000000C4020000000015000000150000001400000008000000014D030D284D030D0000000000000000AD070000000000180000001800000000000000000000000000000000000000D00200000600280000004100630074006900760065005400610062006C00650056006900650077004D006F006400650000000100000008000400000030000000200000005400610062006C00650056006900650077004D006F00640065003A00300000000100000008003800000034002C0030002C003200380034002C0030002C0031003300380030002C0031002C0031003100340030002C0035002C003700350030000000200000005400610062006C00650056006900650077004D006F00640065003A00310000000100000008001E00000032002C0030002C003200380034002C0030002C0032003000370030000000200000005400610062006C00650056006900650077004D006F00640065003A00320000000100000008001E00000032002C0030002C003200380034002C0030002C0031003300380030000000200000005400610062006C00650056006900650077004D006F00640065003A00330000000100000008001E00000032002C0030002C003200380034002C0030002C0031003300380030000000200000005400610062006C00650056006900650077004D006F00640065003A00340000000100000008003E00000034002C0030002C003200380034002C0030002C0031003300380030002C00310032002C0031003600330035002C00310031002C00310030003000350000001D0000001D00000000000000400000000100000001000000640062006F00000046004B005F0055007300650072005F004D0065006D0062006500720073006800690070004700720061006400650000000000000000000000C402000000001E0000001E0000001D00000008000000014F030D284F030D0000000000000000AD0700000000001F0000001F00000000000000380000000100000001000000640062006F00000046004B005F00420061006C0061006E00630065005F00550073006500720049006E0066006F0000000000000000000000C4020000000020000000200000001F00000008000000014F030DA84F030D0000000000000000AD070000000000230000002300000000000000000000000000000000000000D00200000600280000004100630074006900760065005400610062006C00650056006900650077004D006F006400650000000100000008000400000030000000200000005400610062006C00650056006900650077004D006F00640065003A00300000000100000008003800000034002C0030002C003200380034002C0030002C0031003600360035002C0031002C0031003100340030002C0035002C003700350030000000200000005400610062006C00650056006900650077004D006F00640065003A00310000000100000008001E00000032002C0030002C003200380034002C0030002C0032003000370030000000200000005400610062006C00650056006900650077004D006F00640065003A00320000000100000008001E00000032002C0030002C003200380034002C0030002C0031003300380030000000200000005400610062006C00650056006900650077004D006F00640065003A00330000000100000008001E00000032002C0030002C003200380034002C0030002C0031003300380030000000200000005400610062006C00650056006900650077004D006F00640065003A00340000000100000008003E00000034002C0030002C003200380034002C0030002C0031003300380030002C00310032002C0031003600330035002C00310031002C00310030003000350000002400000024000000000000003A0000000100790001000000640062006F00000046004B005F00520065006300680061007200670065005F00550073006500720049006E0066006F0000000000000000000000C4020000000025000000250000002400000008000000014F030D684F030D0000000000000000AD070000000000270000002700000000000000440000000100750001000000640062006F00000046004B005F00520065006300680061007200670065005F004D006500740068006F0064005000610079006D0065006E00740000000000000000000000C4020000000028000000280000002700000008000000014C030DE84C030D0000000000000000AD070000000000290000002900000000000000000000000000000000000000D00200000600280000004100630074006900760065005400610062006C00650056006900650077004D006F006400650000000100000008000400000030000000200000005400610062006C00650056006900650077004D006F00640065003A00300000000100000008003800000034002C0030002C003200380034002C0030002C0031003300380030002C0031002C0031003200300030002C0035002C003700350030000000200000005400610062006C00650056006900650077004D006F00640065003A00310000000100000008001E00000032002C0030002C003200380034002C0030002C0032003000370030000000200000005400610062006C00650056006900650077004D006F00640065003A00320000000100000008001E00000032002C0030002C003200380034002C0030002C0031003300380030000000200000005400610062006C00650056006900650077004D006F00640065003A00330000000100000008001E00000032002C0030002C003200380034002C0030002C0031003300380030000000200000005400610062006C00650056006900650077004D006F00640065003A00340000000100000008003E00000034002C0030002C003200380034002C0030002C0031003300380030002C00310032002C0031003600330035002C00310031002C00310030003000350000002A0000002A00000000000000000000000000000000000000D00200000600280000004100630074006900760065005400610062006C00650056006900650077004D006F006400650000000100000008000400000030000000200000005400610062006C00650056006900650077004D006F00640065003A00300000000100000008003800000034002C0030002C003200380034002C0030002C0031003300380030002C0031002C0031003100340030002C0035002C003700350030000000200000005400610062006C00650056006900650077004D006F00640065003A00310000000100000008001E00000032002C0030002C003200380034002C0030002C0032003000370030000000200000005400610062006C00650056006900650077004D006F00640065003A00320000000100000008001E00000032002C0030002C003200380034002C0030002C0031003300380030000000200000005400610062006C00650056006900650077004D006F00640065003A00330000000100000008001E00000032002C0030002C003200380034002C0030002C0031003300380030000000200000005400610062006C00650056006900650077004D006F00640065003A00340000000100000008003E00000034002C0030002C003200380034002C0030002C0031003300380030002C00310032002C0031003600330035002C00310031002C00310030003000350000002D0000002D000000000000002E00000001C6541501000000640062006F00000046004B005F0053006D0073005F0053006D007300540079007000650000000000000000000000C402000000002E0000002E0000002D000000080000000194010DC094010D0000000000000000AD0700000000002F0000002F000000000000004C000000017CDD7B01000000640062006F00000046004B005F004F00720064006500720073005F0043006F006E00730075006D007000740069006F006E005000610074007400650072006E00730000000000000000000000C4020000000030000000300000002F00000008000000019A010DC09A010D0000000000000000AD070000000000280000002F00000002000000060000008C000000AA0000001400000003000000060000008D000000A40000001D000000040000001800000092000000AA0000000D00000005000000060000008D000000A30000002700000005000000230000008E000000990000001F00000018000000010000006D0000008C0000002400000018000000230000006D000000800000002D0000002A000000290000006F0000009000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010003000000000000000C0000000B0000004E61BC00000000000000000000000000000000000000000000000000000000000000000000000000000000000000DBE6B0E91C81D011AD5100A0C90F573900000200508CD42333ACD601020200001048450000000000000000000000000000000000840100004400610074006100200053006F0075007200630065003D004400450053004B0054004F0050002D0032004E00500051005200360033003B0049006E0069007400690061006C00200043006100740061006C006F0067003D004D0065006D006200650072004D0061006E006100670065006D0065006E007400440042003B0049006E00740065006700720061007400650064002000530065006300750072006900740079003D0054007200750065003B004D0075006C007400690070006C00650041006300740069007600650052006500730075006C00740053006500740073003D00460061006C00730065003B005000610063006B00650074002000530069007A0065003D0034003000390036003B004100700070006C00690063006100740069006F006E0020004E0061006D0065003D0022004D006900630072006F0073006F00660074002000530051004C00200053006500720076006500720020004D0061006E006100670065006D0065006E0074002000530074007500640069006F002200000000800500140000004400690061006700720061006D005F0030000000000226001000000053006D0073005400790070006500000008000000640062006F000000000226000800000053006D007300000008000000640062006F000000000226001200000052006500630068006100720067006500000008000000640062006F0000000002260012000000550073006500720049006E0066006F00000008000000640062006F000000000226000E0000004F0072006400650072007300000008000000640062006F000000000226001C0000004D006500740068006F0064005000610079006D0065006E007400000008000000640062006F00000000022600200000004D0065006D00620065007200730068006900700047007200610064006500000008000000640062006F000000000226002000000043006F006E00730075006D007000740069006F006E005400790070006500000008000000640062006F000000000226002800000043006F006E00730075006D007000740069006F006E005000610074007400650072006E007300000008000000640062006F0000000002240010000000420061006C0061006E0063006500000008000000640062006F00000001000000D68509B3BB6BF2459AB8371664F0327008004E0000007B00310036003300340043004400440037002D0030003800380038002D0034003200450033002D0039004600410032002D004200360044003300320035003600330042003900310044007D0000000000000000000000000000000000000000000000000000000000010003000000000000000C0000000B0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000062885214)
GO

SET IDENTITY_INSERT [dbo].[sysdiagrams] OFF
GO


-- ----------------------------
-- Table structure for UserInfo
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[UserInfo]') AND type IN ('U'))
	DROP TABLE [dbo].[UserInfo]
GO

CREATE TABLE [dbo].[UserInfo] (
  [CardNo] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [MemberState] char(10) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Name] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [PassWord] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [Wechat] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [QrCode] nvarchar(150) COLLATE Chinese_PRC_CI_AS  NULL,
  [Phone] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Sex] char(10) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Birthday] datetime  NOT NULL,
  [LevelNo] int  NOT NULL,
  [Note] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [OpenCardDate] datetime  NOT NULL,
  [DueToTime] datetime  NULL
)
GO

ALTER TABLE [dbo].[UserInfo] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of UserInfo
-- ----------------------------
INSERT INTO [dbo].[UserInfo] ([CardNo], [MemberState], [Name], [PassWord], [Wechat], [QrCode], [Phone], [Sex], [Birthday], [LevelNo], [Note], [OpenCardDate], [DueToTime]) VALUES (N'2979858', N'正常      ', N'温某文', N'', N'', N'https://u.wechat.com/ELiXvnzgeMnP8cmh_ZvDoqQ', N'15880523015', N'男        ', N'1999-01-01 00:00:00.000', N'4', N'', N'2020-10-27 15:51:09.523', N'1999-01-01 00:00:00.000')
GO

INSERT INTO [dbo].[UserInfo] ([CardNo], [MemberState], [Name], [PassWord], [Wechat], [QrCode], [Phone], [Sex], [Birthday], [LevelNo], [Note], [OpenCardDate], [DueToTime]) VALUES (N'3272158', N'正常      ', N'郑某鹏', N'', N'', N'https://qm.qq.com/cgi-bin/qm/qr?k=WsnPhnnMlrgU9uQikF4tMwJKLLlpWfJT&noverify=0', N'17720743464', N'男        ', N'1999-01-01 00:00:00.000', N'4', N'班级测试人员', N'2020-10-27 15:45:48.320', N'1999-01-01 00:00:00.000')
GO

INSERT INTO [dbo].[UserInfo] ([CardNo], [MemberState], [Name], [PassWord], [Wechat], [QrCode], [Phone], [Sex], [Birthday], [LevelNo], [Note], [OpenCardDate], [DueToTime]) VALUES (N'4421748', N'锁定      ', N'马某勋', N'', N'', N'https://u.wechat.com/MDJUQrvdsmnV_3XgVIsv86o








', N'18965138288', N'男        ', N'1999-01-01 00:00:00.000', N'4', N'班级测试人员', N'2020-10-27 15:43:37.750', N'1999-01-01 00:00:00.000')
GO

INSERT INTO [dbo].[UserInfo] ([CardNo], [MemberState], [Name], [PassWord], [Wechat], [QrCode], [Phone], [Sex], [Birthday], [LevelNo], [Note], [OpenCardDate], [DueToTime]) VALUES (N'4591626', N'正常      ', N'童某兵', N'', N'', N'https://u.wechat.com/MDRFCFqUBj2yMbxlKYxn5gM', N'18679631721', N'男        ', N'1999-01-01 00:00:00.000', N'2', N'', N'2020-10-27 15:48:53.607', N'1999-01-01 00:00:00.000')
GO

INSERT INTO [dbo].[UserInfo] ([CardNo], [MemberState], [Name], [PassWord], [Wechat], [QrCode], [Phone], [Sex], [Birthday], [LevelNo], [Note], [OpenCardDate], [DueToTime]) VALUES (N'4727159', N'正常      ', N'林某辉', N'123', N'linhohui', N'', N'18559440650', N'男        ', N'2000-02-14 00:00:00.000', N'4', N'这是管理员的测试账号', N'2020-10-26 11:38:04.007', N'1999-01-01 00:00:00.000')
GO

INSERT INTO [dbo].[UserInfo] ([CardNo], [MemberState], [Name], [PassWord], [Wechat], [QrCode], [Phone], [Sex], [Birthday], [LevelNo], [Note], [OpenCardDate], [DueToTime]) VALUES (N'5253131', N'正常      ', N'罗某钰', N'', N'', N'https://u.wechat.com/MO5dIN3IoUhblV2STH7633w', N'18398992750', N'男        ', N'1999-01-01 00:00:00.000', N'4', N'班级测试人员', N'2020-10-27 15:47:49.770', N'1999-01-01 00:00:00.000')
GO

INSERT INTO [dbo].[UserInfo] ([CardNo], [MemberState], [Name], [PassWord], [Wechat], [QrCode], [Phone], [Sex], [Birthday], [LevelNo], [Note], [OpenCardDate], [DueToTime]) VALUES (N'6870325', N'正常      ', N'小关', N'', N'', N'https://u.wechat.com/MCjUXKZ2nUoqfJjca9EF_s8', N'18559440650', N'男        ', N'1999-01-01 00:00:00.000', N'1', N'', N'2020-10-27 16:35:30.817', N'1999-01-01 00:00:00.000')
GO

INSERT INTO [dbo].[UserInfo] ([CardNo], [MemberState], [Name], [PassWord], [Wechat], [QrCode], [Phone], [Sex], [Birthday], [LevelNo], [Note], [OpenCardDate], [DueToTime]) VALUES (N'8725159', N'正常      ', N'朱老师', N'', N'', N'https://u.wechat.com/MBXjVORlYuOfQYsoZfuxrRE', N'15959210724', N'男        ', N'1999-01-01 00:00:00.000', N'3', N'', N'2020-10-28 10:30:44.560', N'1999-01-01 00:00:00.000')
GO


-- ----------------------------
-- View structure for view_userInfo
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[view_userInfo]') AND type IN ('V'))
	DROP VIEW [dbo].[view_userInfo]
GO

CREATE VIEW [dbo].[view_userInfo] AS select CardNo,Name,Sex
 from UserInfo
GO


-- ----------------------------
-- procedure structure for sp_upgraddiagrams
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_upgraddiagrams]') AND type IN ('FN', 'FS', 'FT', 'IF', 'TF'))
	DROP PROCEDURE[dbo].[sp_upgraddiagrams]
GO

CREATE PROCEDURE [dbo].[sp_upgraddiagrams]
	AS
	BEGIN
		IF OBJECT_ID(N'dbo.sysdiagrams') IS NOT NULL
			return 0;
	
		CREATE TABLE dbo.sysdiagrams
		(
			name sysname NOT NULL,
			principal_id int NOT NULL,	-- we may change it to varbinary(85)
			diagram_id int PRIMARY KEY IDENTITY,
			version int,
	
			definition varbinary(max)
			CONSTRAINT UK_principal_name UNIQUE
			(
				principal_id,
				name
			)
		);


		/* Add this if we need to have some form of extended properties for diagrams */
		/*
		IF OBJECT_ID(N'dbo.sysdiagram_properties') IS NULL
		BEGIN
			CREATE TABLE dbo.sysdiagram_properties
			(
				diagram_id int,
				name sysname,
				value varbinary(max) NOT NULL
			)
		END
		*/

		IF OBJECT_ID(N'dbo.dtproperties') IS NOT NULL
		begin
			insert into dbo.sysdiagrams
			(
				[name],
				[principal_id],
				[version],
				[definition]
			)
			select	 
				convert(sysname, dgnm.[uvalue]),
				DATABASE_PRINCIPAL_ID(N'dbo'),			-- will change to the sid of sa
				0,							-- zero for old format, dgdef.[version],
				dgdef.[lvalue]
			from dbo.[dtproperties] dgnm
				inner join dbo.[dtproperties] dggd on dggd.[property] = 'DtgSchemaGUID' and dggd.[objectid] = dgnm.[objectid]	
				inner join dbo.[dtproperties] dgdef on dgdef.[property] = 'DtgSchemaDATA' and dgdef.[objectid] = dgnm.[objectid]
				
			where dgnm.[property] = 'DtgSchemaNAME' and dggd.[uvalue] like N'_EA3E6268-D998-11CE-9454-00AA00A3F36E_' 
			return 2;
		end
		return 1;
	END
GO


-- ----------------------------
-- procedure structure for sp_helpdiagrams
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_helpdiagrams]') AND type IN ('FN', 'FS', 'FT', 'IF', 'TF'))
	DROP PROCEDURE[dbo].[sp_helpdiagrams]
GO

CREATE PROCEDURE [dbo].[sp_helpdiagrams]
	(
		@diagramname sysname = NULL,
		@owner_id int = NULL
	)
	WITH EXECUTE AS N'dbo'
	AS
	BEGIN
		DECLARE @user sysname
		DECLARE @dboLogin bit
		EXECUTE AS CALLER;
			SET @user = USER_NAME();
			SET @dboLogin = CONVERT(bit,IS_MEMBER('db_owner'));
		REVERT;
		SELECT
			[Database] = DB_NAME(),
			[Name] = name,
			[ID] = diagram_id,
			[Owner] = USER_NAME(principal_id),
			[OwnerID] = principal_id
		FROM
			sysdiagrams
		WHERE
			(@dboLogin = 1 OR USER_NAME(principal_id) = @user) AND
			(@diagramname IS NULL OR name = @diagramname) AND
			(@owner_id IS NULL OR principal_id = @owner_id)
		ORDER BY
			4, 5, 1
	END
GO


-- ----------------------------
-- procedure structure for sp_helpdiagramdefinition
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_helpdiagramdefinition]') AND type IN ('FN', 'FS', 'FT', 'IF', 'TF'))
	DROP PROCEDURE[dbo].[sp_helpdiagramdefinition]
GO

CREATE PROCEDURE [dbo].[sp_helpdiagramdefinition]
	(
		@diagramname 	sysname,
		@owner_id	int	= null 		
	)
	WITH EXECUTE AS N'dbo'
	AS
	BEGIN
		set nocount on

		declare @theId 		int
		declare @IsDbo 		int
		declare @DiagId		int
		declare @UIDFound	int
	
		if(@diagramname is null)
		begin
			RAISERROR (N'E_INVALIDARG', 16, 1);
			return -1
		end
	
		execute as caller;
		select @theId = DATABASE_PRINCIPAL_ID();
		select @IsDbo = IS_MEMBER(N'db_owner');
		if(@owner_id is null)
			select @owner_id = @theId;
		revert; 
	
		select @DiagId = diagram_id, @UIDFound = principal_id from dbo.sysdiagrams where principal_id = @owner_id and name = @diagramname;
		if(@DiagId IS NULL or (@IsDbo = 0 and @UIDFound <> @theId ))
		begin
			RAISERROR ('Diagram does not exist or you do not have permission.', 16, 1);
			return -3
		end

		select version, definition FROM dbo.sysdiagrams where diagram_id = @DiagId ; 
		return 0
	END
GO


-- ----------------------------
-- procedure structure for sp_creatediagram
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_creatediagram]') AND type IN ('FN', 'FS', 'FT', 'IF', 'TF'))
	DROP PROCEDURE[dbo].[sp_creatediagram]
GO

CREATE PROCEDURE [dbo].[sp_creatediagram]
	(
		@diagramname 	sysname,
		@owner_id		int	= null, 	
		@version 		int,
		@definition 	varbinary(max)
	)
	WITH EXECUTE AS 'dbo'
	AS
	BEGIN
		set nocount on
	
		declare @theId int
		declare @retval int
		declare @IsDbo	int
		declare @userName sysname
		if(@version is null or @diagramname is null)
		begin
			RAISERROR (N'E_INVALIDARG', 16, 1);
			return -1
		end
	
		execute as caller;
		select @theId = DATABASE_PRINCIPAL_ID(); 
		select @IsDbo = IS_MEMBER(N'db_owner');
		revert; 
		
		if @owner_id is null
		begin
			select @owner_id = @theId;
		end
		else
		begin
			if @theId <> @owner_id
			begin
				if @IsDbo = 0
				begin
					RAISERROR (N'E_INVALIDARG', 16, 1);
					return -1
				end
				select @theId = @owner_id
			end
		end
		-- next 2 line only for test, will be removed after define name unique
		if EXISTS(select diagram_id from dbo.sysdiagrams where principal_id = @theId and name = @diagramname)
		begin
			RAISERROR ('The name is already used.', 16, 1);
			return -2
		end
	
		insert into dbo.sysdiagrams(name, principal_id , version, definition)
				VALUES(@diagramname, @theId, @version, @definition) ;
		
		select @retval = @@IDENTITY 
		return @retval
	END
GO


-- ----------------------------
-- procedure structure for sp_renamediagram
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_renamediagram]') AND type IN ('FN', 'FS', 'FT', 'IF', 'TF'))
	DROP PROCEDURE[dbo].[sp_renamediagram]
GO

CREATE PROCEDURE [dbo].[sp_renamediagram]
	(
		@diagramname 		sysname,
		@owner_id		int	= null,
		@new_diagramname	sysname
	
	)
	WITH EXECUTE AS 'dbo'
	AS
	BEGIN
		set nocount on
		declare @theId 			int
		declare @IsDbo 			int
		
		declare @UIDFound 		int
		declare @DiagId			int
		declare @DiagIdTarg		int
		declare @u_name			sysname
		if((@diagramname is null) or (@new_diagramname is null))
		begin
			RAISERROR ('Invalid value', 16, 1);
			return -1
		end
	
		EXECUTE AS CALLER;
		select @theId = DATABASE_PRINCIPAL_ID();
		select @IsDbo = IS_MEMBER(N'db_owner'); 
		if(@owner_id is null)
			select @owner_id = @theId;
		REVERT;
	
		select @u_name = USER_NAME(@owner_id)
	
		select @DiagId = diagram_id, @UIDFound = principal_id from dbo.sysdiagrams where principal_id = @owner_id and name = @diagramname 
		if(@DiagId IS NULL or (@IsDbo = 0 and @UIDFound <> @theId))
		begin
			RAISERROR ('Diagram does not exist or you do not have permission.', 16, 1)
			return -3
		end
	
		-- if((@u_name is not null) and (@new_diagramname = @diagramname))	-- nothing will change
		--	return 0;
	
		if(@u_name is null)
			select @DiagIdTarg = diagram_id from dbo.sysdiagrams where principal_id = @theId and name = @new_diagramname
		else
			select @DiagIdTarg = diagram_id from dbo.sysdiagrams where principal_id = @owner_id and name = @new_diagramname
	
		if((@DiagIdTarg is not null) and  @DiagId <> @DiagIdTarg)
		begin
			RAISERROR ('The name is already used.', 16, 1);
			return -2
		end		
	
		if(@u_name is null)
			update dbo.sysdiagrams set [name] = @new_diagramname, principal_id = @theId where diagram_id = @DiagId
		else
			update dbo.sysdiagrams set [name] = @new_diagramname where diagram_id = @DiagId
		return 0
	END
GO


-- ----------------------------
-- procedure structure for sp_alterdiagram
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_alterdiagram]') AND type IN ('FN', 'FS', 'FT', 'IF', 'TF'))
	DROP PROCEDURE[dbo].[sp_alterdiagram]
GO

CREATE PROCEDURE [dbo].[sp_alterdiagram]
	(
		@diagramname 	sysname,
		@owner_id	int	= null,
		@version 	int,
		@definition 	varbinary(max)
	)
	WITH EXECUTE AS 'dbo'
	AS
	BEGIN
		set nocount on
	
		declare @theId 			int
		declare @retval 		int
		declare @IsDbo 			int
		
		declare @UIDFound 		int
		declare @DiagId			int
		declare @ShouldChangeUID	int
	
		if(@diagramname is null)
		begin
			RAISERROR ('Invalid ARG', 16, 1)
			return -1
		end
	
		execute as caller;
		select @theId = DATABASE_PRINCIPAL_ID();	 
		select @IsDbo = IS_MEMBER(N'db_owner'); 
		if(@owner_id is null)
			select @owner_id = @theId;
		revert;
	
		select @ShouldChangeUID = 0
		select @DiagId = diagram_id, @UIDFound = principal_id from dbo.sysdiagrams where principal_id = @owner_id and name = @diagramname 
		
		if(@DiagId IS NULL or (@IsDbo = 0 and @theId <> @UIDFound))
		begin
			RAISERROR ('Diagram does not exist or you do not have permission.', 16, 1);
			return -3
		end
	
		if(@IsDbo <> 0)
		begin
			if(@UIDFound is null or USER_NAME(@UIDFound) is null) -- invalid principal_id
			begin
				select @ShouldChangeUID = 1 ;
			end
		end

		-- update dds data			
		update dbo.sysdiagrams set definition = @definition where diagram_id = @DiagId ;

		-- change owner
		if(@ShouldChangeUID = 1)
			update dbo.sysdiagrams set principal_id = @theId where diagram_id = @DiagId ;

		-- update dds version
		if(@version is not null)
			update dbo.sysdiagrams set version = @version where diagram_id = @DiagId ;

		return 0
	END
GO


-- ----------------------------
-- procedure structure for sp_dropdiagram
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_dropdiagram]') AND type IN ('FN', 'FS', 'FT', 'IF', 'TF'))
	DROP PROCEDURE[dbo].[sp_dropdiagram]
GO

CREATE PROCEDURE [dbo].[sp_dropdiagram]
	(
		@diagramname 	sysname,
		@owner_id	int	= null
	)
	WITH EXECUTE AS 'dbo'
	AS
	BEGIN
		set nocount on
		declare @theId 			int
		declare @IsDbo 			int
		
		declare @UIDFound 		int
		declare @DiagId			int
	
		if(@diagramname is null)
		begin
			RAISERROR ('Invalid value', 16, 1);
			return -1
		end
	
		EXECUTE AS CALLER;
		select @theId = DATABASE_PRINCIPAL_ID();
		select @IsDbo = IS_MEMBER(N'db_owner'); 
		if(@owner_id is null)
			select @owner_id = @theId;
		REVERT; 
		
		select @DiagId = diagram_id, @UIDFound = principal_id from dbo.sysdiagrams where principal_id = @owner_id and name = @diagramname 
		if(@DiagId IS NULL or (@IsDbo = 0 and @UIDFound <> @theId))
		begin
			RAISERROR ('Diagram does not exist or you do not have permission.', 16, 1)
			return -3
		end
	
		delete from dbo.sysdiagrams where diagram_id = @DiagId;
	
		return 0;
	END
GO


-- ----------------------------
-- function structure for fn_diagramobjects
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[fn_diagramobjects]') AND type IN ('FN', 'FS', 'FT', 'IF', 'TF'))
	DROP FUNCTION[dbo].[fn_diagramobjects]
GO

CREATE FUNCTION [dbo].[fn_diagramobjects]() 
	RETURNS int
	WITH EXECUTE AS N'dbo'
	AS
	BEGIN
		declare @id_upgraddiagrams		int
		declare @id_sysdiagrams			int
		declare @id_helpdiagrams		int
		declare @id_helpdiagramdefinition	int
		declare @id_creatediagram	int
		declare @id_renamediagram	int
		declare @id_alterdiagram 	int 
		declare @id_dropdiagram		int
		declare @InstalledObjects	int

		select @InstalledObjects = 0

		select 	@id_upgraddiagrams = object_id(N'dbo.sp_upgraddiagrams'),
			@id_sysdiagrams = object_id(N'dbo.sysdiagrams'),
			@id_helpdiagrams = object_id(N'dbo.sp_helpdiagrams'),
			@id_helpdiagramdefinition = object_id(N'dbo.sp_helpdiagramdefinition'),
			@id_creatediagram = object_id(N'dbo.sp_creatediagram'),
			@id_renamediagram = object_id(N'dbo.sp_renamediagram'),
			@id_alterdiagram = object_id(N'dbo.sp_alterdiagram'), 
			@id_dropdiagram = object_id(N'dbo.sp_dropdiagram')

		if @id_upgraddiagrams is not null
			select @InstalledObjects = @InstalledObjects + 1
		if @id_sysdiagrams is not null
			select @InstalledObjects = @InstalledObjects + 2
		if @id_helpdiagrams is not null
			select @InstalledObjects = @InstalledObjects + 4
		if @id_helpdiagramdefinition is not null
			select @InstalledObjects = @InstalledObjects + 8
		if @id_creatediagram is not null
			select @InstalledObjects = @InstalledObjects + 16
		if @id_renamediagram is not null
			select @InstalledObjects = @InstalledObjects + 32
		if @id_alterdiagram  is not null
			select @InstalledObjects = @InstalledObjects + 64
		if @id_dropdiagram is not null
			select @InstalledObjects = @InstalledObjects + 128
		
		return @InstalledObjects 
	END
GO


-- ----------------------------
-- Primary Key structure for table Balance
-- ----------------------------
ALTER TABLE [dbo].[Balance] ADD CONSTRAINT [PK_Balance] PRIMARY KEY CLUSTERED ([CardNo])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for ConsumptionPatterns
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[ConsumptionPatterns]', RESEED, 4)
GO


-- ----------------------------
-- Primary Key structure for table ConsumptionPatterns
-- ----------------------------
ALTER TABLE [dbo].[ConsumptionPatterns] ADD CONSTRAINT [PK_ConsumptionPatterns] PRIMARY KEY CLUSTERED ([ConsumptionPatternsNo])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for ConsumptionType
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[ConsumptionType]', RESEED, 9)
GO


-- ----------------------------
-- Primary Key structure for table ConsumptionType
-- ----------------------------
ALTER TABLE [dbo].[ConsumptionType] ADD CONSTRAINT [PK_ConsumptionType] PRIMARY KEY CLUSTERED ([ConsumptionTypeNo])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for MembershipGrade
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[MembershipGrade]', RESEED, 6)
GO


-- ----------------------------
-- Primary Key structure for table MembershipGrade
-- ----------------------------
ALTER TABLE [dbo].[MembershipGrade] ADD CONSTRAINT [PK_MembershipGrade] PRIMARY KEY CLUSTERED ([LevelNo])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for MethodPayment
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[MethodPayment]', RESEED, 3)
GO


-- ----------------------------
-- Primary Key structure for table MethodPayment
-- ----------------------------
ALTER TABLE [dbo].[MethodPayment] ADD CONSTRAINT [PK_MethodPayment] PRIMARY KEY CLUSTERED ([MethodPaymentNo])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for QueryMode
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[QueryMode]', RESEED, 4)
GO


-- ----------------------------
-- Primary Key structure for table QueryMode
-- ----------------------------
ALTER TABLE [dbo].[QueryMode] ADD CONSTRAINT [PK_QueryMode] PRIMARY KEY CLUSTERED ([QueryNo])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for SmsType
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[SmsType]', RESEED, 4)
GO


-- ----------------------------
-- Primary Key structure for table SmsType
-- ----------------------------
ALTER TABLE [dbo].[SmsType] ADD CONSTRAINT [PK_MessageType] PRIMARY KEY CLUSTERED ([MessageTypeNo])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for sysdiagrams
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[sysdiagrams]', RESEED, 1)
GO


-- ----------------------------
-- Uniques structure for table sysdiagrams
-- ----------------------------
ALTER TABLE [dbo].[sysdiagrams] ADD CONSTRAINT [UK_principal_name] UNIQUE NONCLUSTERED ([principal_id] ASC, [name] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table sysdiagrams
-- ----------------------------
ALTER TABLE [dbo].[sysdiagrams] ADD CONSTRAINT [PK__sysdiagr__C2B05B610CBAE877] PRIMARY KEY CLUSTERED ([diagram_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table UserInfo
-- ----------------------------
ALTER TABLE [dbo].[UserInfo] ADD CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED ([CardNo])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Foreign Keys structure for table Balance
-- ----------------------------
ALTER TABLE [dbo].[Balance] ADD CONSTRAINT [FK_Balance_UserInfo] FOREIGN KEY ([CardNo]) REFERENCES [dbo].[UserInfo] ([CardNo]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO


-- ----------------------------
-- Foreign Keys structure for table Orders
-- ----------------------------
ALTER TABLE [dbo].[Orders] ADD CONSTRAINT [FK_Orders_MethodPayment] FOREIGN KEY ([MethodPaymentNo]) REFERENCES [dbo].[MethodPayment] ([MethodPaymentNo]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO

ALTER TABLE [dbo].[Orders] ADD CONSTRAINT [FK_Orders_ConsumptionPatterns] FOREIGN KEY ([ConsumptionTypeNo]) REFERENCES [dbo].[ConsumptionPatterns] ([ConsumptionPatternsNo]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO

ALTER TABLE [dbo].[Orders] ADD CONSTRAINT [FK_Orders_ConsumptionType] FOREIGN KEY ([ConsumptionTypeNo]) REFERENCES [dbo].[ConsumptionType] ([ConsumptionTypeNo]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO


-- ----------------------------
-- Foreign Keys structure for table Recharge
-- ----------------------------
ALTER TABLE [dbo].[Recharge] ADD CONSTRAINT [FK_Recharge_MethodPayment] FOREIGN KEY ([MethodPaymentNo]) REFERENCES [dbo].[MethodPayment] ([MethodPaymentNo]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO

ALTER TABLE [dbo].[Recharge] ADD CONSTRAINT [FK_Recharge_UserInfo] FOREIGN KEY ([CardNo]) REFERENCES [dbo].[UserInfo] ([CardNo]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO


-- ----------------------------
-- Foreign Keys structure for table Sms
-- ----------------------------
ALTER TABLE [dbo].[Sms] ADD CONSTRAINT [FK_Sms_SmsType] FOREIGN KEY ([MessageTypeNo]) REFERENCES [dbo].[SmsType] ([MessageTypeNo]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO


-- ----------------------------
-- Foreign Keys structure for table UserInfo
-- ----------------------------
ALTER TABLE [dbo].[UserInfo] ADD CONSTRAINT [FK_User_MembershipGrade] FOREIGN KEY ([LevelNo]) REFERENCES [dbo].[MembershipGrade] ([LevelNo]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO

